------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  E:\REStat_MS14767_Vol96(2)\Data preparation Compustat segment\2_segmentdata.log
  log type:  text
 opened on:  18 Dec 2014, 18:04:57

. 
. use "raw data\segments_1986-1999.dta", clear

. 
. ****************************************************************************
. *Drop from the segment datafile all observations relative to the
. *geographic segments. We will work only with business-segment data
. ****************************************************************************
. 
. keep if  stype == "BUSSEG"
(287703 observations deleted)

. drop stype

. 
. ****************************************************************************
. *When the Source Year does not match the Data Year, the information 
. *presented in that record will be Restated Data.
. *Since we are interested in the historical data, we drop the restated records:
. ******************************************************************************
. drop if datadate !=srcdate
(47795 observations deleted)

. 
. ****************************************************************************
. *When the SIC Information is missing, we can not use this observation
. *Thus we have to drop it:
. ****************************************************************************
. 
. drop  if sics1 == ""
(4361 observations deleted)

. 
. *separate the year information from the entire date:
. gen year = yofd( datadate)

. label var year "fiscal year"

. 
. keep  gvkey sales salexg ias rds  sics1 tic cusip year conm

. drop if sales ==.
(1001 observations deleted)

. 
. ****************************************************************************
. * sales are changed into sales_segm by substracting the sales from exports "salexp"
. * This Step is equivalent to the substraction of the "foreigne sales",
. * which was done in the "compustatvars.do"-file. 
. ****************************************************************************
. 
. replace salexg=0 if  salexg==.
(170989 real changes made)

. gen sales_new=sales- salexg

. count if sales_new<0
  230

. replace sales_new=. if sales_new<0
(230 real changes made, 230 to missing)

. count if sales_new==.
  230

. drop if sales_new==.
(230 observations deleted)

. drop sales salexg

. label var sales_new "Sales - foreign sales"

. 
. rename sales_new sales_segm

. rename ias ta_segm

. rename rds rds_segm 

. rename cusip cusip_segm

. 
. rename tic ticker

. 
. ****************************************************************************
. * this step is equivalent to the cleancompustat.do procedure.
. * Even if there are not such double entries in the the segment database,
. * it is usefull to drop the same firms.
. * If we would not do that, the double entries would emerge after 
. * merging the compustat data with the segment data. 
. ****************************************************************************
. 
. gen droplater=.
(170786 missing values generated)

. replace droplater=1 if ticker=="ADY." /* ADB SYSTEMS INTL LTD, surviving ticker: 3ADBYF */
(0 real changes made)

. replace droplater=1 if ticker=="ATY." /* ATI TECHNOLOGIES INC, surviving ticker: ATYT */
(0 real changes made)

. replace droplater=1 if ticker=="ABZ" /* ABER DIAMOND CORP, surviving ticker: ABER */
(0 real changes made)

. replace droplater=1 if ticker=="A." /* ABITIBI CONSOLIDATED INC, surviving ticker: ABY */
(0 real changes made)

. replace droplater=1 if ticker=="ACE.B" /* ACE AVIATION HOLDINGS INC, surviving ticker: ACEBF */
(0 real changes made)

. replace droplater=1 if ticker=="AHX" /* ADHEREX TECHNOLOGIES INC, surviving ticker: ADH */
(0 real changes made)

. replace droplater=1 if ticker=="AAV" /* ADVANTAGE ENERGY INCOME FUND, surviving ticker: AVN.U */
(0 real changes made)

. replace droplater=1 if ticker=="AEZS" /* AETERNA ZENTARIS INC, surviving ticker: AEZ. */
(2 real changes made)

. replace droplater=1 if ticker=="AEM." /* AGNICO EAGLE MINES LTD, surviving ticker: AEM */
(0 real changes made)

. replace droplater=1 if ticker=="AGU." /* AGRIUM INC, surviving ticker: AGU */
(0 real changes made)

. replace droplater=1 if ticker=="AGT." /* AIMGLOBAL TECHNOLOGIES INC, surviving ticker: AIMG */
(0 real changes made)

. replace droplater=1 if ticker=="AL." /* ALCAN INC, surviving ticker: AL */
(0 real changes made)

. replace droplater=1 if ticker=="0192B" /* ALDERWOODS GROUP INC, surviving ticker: AWGI */
(0 real changes made)

. replace droplater=1 if ticker=="0236B" /* ALGOMA STEEL INC, surviving ticker: AGA */
(0 real changes made)

. replace droplater=1 if ticker=="AAC.NV.B" /* ALLIANCE ATLANTIS COMM -CL B, surviving ticker: AACB */
(0 real changes made)

. replace droplater=1 if ticker=="AAU" /* ALMADEN MINERALS LTD, surviving ticker: AAM. */
(0 real changes made)

. replace droplater=1 if ticker=="3251B" /* ALTAIR NANOTECHNOLOGIES INC, surviving ticker: ALTI */
(0 real changes made)

. replace droplater=1 if ticker=="ANPI" /* ANGIOTECH PHARMACEUTICALS, surviving ticker: ANP. */
(0 real changes made)

. replace droplater=1 if ticker=="ASW." /* ANGLO SWISS RESOURCES INC, surviving ticker: 3ASWRF */
(0 real changes made)

. replace droplater=1 if ticker=="AOM." /* ANORMED INC, surviving ticker: AOM */
(0 real changes made)

. replace droplater=1 if ticker=="ARQ" /* ANOORAQ RESOURCES CORP, surviving ticker: ANO */
(0 real changes made)

. replace droplater=1 if ticker=="APG" /* APOLLO GOLD CORP, surviving ticker: AGT */
(0 real changes made)

. replace droplater=1 if ticker=="APQ." /* ASIA PACIFIC RESOURCES LTD, surviving ticker: APQCF */
(0 real changes made)

. replace droplater=1 if ticker=="ASR." /* ASPEN GROUP RESOURCES CORP, surviving ticker: ASRPF */
(0 real changes made)

. replace droplater=1 if ticker=="ASV" /* ASPREVA PHARMACEUTICALS CORP, surviving ticker: ASPV */
(0 real changes made)

. replace droplater=1 if ticker=="AZK" /* AURIZON MINES LTD, surviving ticker: ARZ. */
(0 real changes made)

. replace droplater=1 if ticker=="APX." /* AUSTRAL PACIFIC ENERGY LTD, surviving ticker: AEN */
(0 real changes made)

. replace droplater=1 if ticker=="ASM." /* AVINO SILVER&GOLD MINES LTD, surviving ticker: 3ASGMF */
(0 real changes made)

. replace droplater=1 if ticker=="AZC." /* AZCO MINING INC/DE, surviving ticker: AZMN */
(0 real changes made)

. replace droplater=1 if ticker=="AXP." /* AXCAN PHARMA INC, surviving ticker: AXCA */
(0 real changes made)

. replace droplater=1 if ticker=="BCE." /* BCE INC, surviving ticker: BCE */
(0 real changes made)

. replace droplater=1 if ticker=="BPR." /* BPI INDUSTRIES INC, surviving ticker: BPG */
(0 real changes made)

. replace droplater=1 if ticker=="BLD." /* BALLARD POWER SYSTEMS INC, surviving ticker: BLDP */
(0 real changes made)

. replace droplater=1 if ticker=="BAA." /* BANRO CORP, surviving ticker: BAA */
(0 real changes made)

. replace droplater=1 if ticker=="ABX." /* BARRICK GOLD CORP, surviving ticker: ABX */
(0 real changes made)

. replace droplater=1 if ticker=="BTI." /* BATTERY TECHNOLOGIES INC, surviving ticker: BTIOQ */
(0 real changes made)

. replace droplater=1 if ticker=="BI." /* BELL CANADA INTL INC, surviving ticker: BCICF */
(0 real changes made)

. replace droplater=1 if ticker=="BCE1." /* BELL CANADA, surviving ticker: BCE1 */
(0 real changes made)

. replace droplater=1 if ticker=="BGO." /* BEMA GOLD CORP, surviving ticker: BGO */
(0 real changes made)

. replace droplater=1 if ticker=="BEL" /* BENNETT ENVIRONMENTAL INC, surviving ticker: BEV. */
(0 real changes made)

. replace droplater=1 if ticker=="BR.U" /* BIG ROCK BREWERY INCOME TR, surviving ticker: BRBMF */
(0 real changes made)

. replace droplater=1 if ticker=="7520B" /* BIOJECT MEDICAL TECHNOL, surviving ticker: BJCT */
(0 real changes made)

. replace droplater=1 if ticker=="BMD." /* BIRCH MOUNTAIN RESOURCES LTD, surviving ticker: BMD */
(0 real changes made)

. replace droplater=1 if ticker=="BVF." /* BIOVAIL CORP, surviving ticker: BVF */
(0 real changes made)

. replace droplater=1 if ticker=="BRA" /* BIOMIRA INC, surviving ticker: BIOM */
(0 real changes made)

. replace droplater=1 if ticker=="BMM.U" /* BLACK MOUNTAIN CAPITAL CORP, surviving ticker: 3BMMUF */
(0 real changes made)

. replace droplater=1 if ticker=="BOWFF" /* BOARDWALK REAL ESTATE TRUST, survivin ticker: BEI.U */
(1 real change made)

. replace droplater=1 if ticker=="BOW1" /* BOWATER PULP & PAPER, surviving ricker: BOW1. */
(0 real changes made)

. replace droplater=1 if ticker=="BZO" /* BRAZAURO RESOURCES CORP, surviving ticker: BZOFF */
(0 real changes made)

. replace droplater=1 if ticker=="BWR." /* BREAKWATER RESOURCES LTD, surviving ticker: 3BWLRF */
(0 real changes made)

. replace droplater=1 if ticker=="GGG.Z" /* BRONX VENTURES INC, surviving ticker: 3BRXVF */
(0 real changes made)

. replace droplater=1 if ticker=="BAM.LV.A" /* BROOKFIELD ASSET MANAGEMENT, surviving ticker: BAM */
(0 real changes made)

. replace droplater=1 if ticker=="BPO" /* BROOKFIELD PROPERTIES CORP, surviving ticker: BPO. */
(4 real changes made)

. replace droplater=1 if ticker=="CGT" /* CAE INC, surviving ticker: CAE. */
(0 real changes made)

. replace droplater=1 if ticker=="CFK" /* CE FRANKLIN LTD, surviving ticker: CFT. */
(7 real changes made)

. replace droplater=1 if ticker=="FLY.SV.A" /* CHC HELICOPTER CORP  -CL A, surviving ticker: FLI */
(0 real changes made)

. replace droplater=1 if ticker=="HCH." /* MERRILL LYNCH CANADA CP HLDR, surviving ticker: HCH */
(0 real changes made)

. replace droplater=1 if ticker=="CBJ." /* CAMBIOR INC, surviving ticker: CBJ */
(0 real changes made)

. replace droplater=1 if ticker=="TTV." /* CABLETEL COMMUNICATIONS CORP, surviving ticker: CCMTF */
(0 real changes made)

. replace droplater=1 if ticker=="CCO." /* CAMECO CORP, surviving ticker: CCJ */
(0 real changes made)

. replace droplater=1 if ticker=="CCH." /* CAMPBELL RESOURCES INC, surviving ticker: 3CBLRF */
(0 real changes made)

. replace droplater=1 if ticker=="CL." /* CANADA LIFE FINANCIAL CORP, surviving ticker: CLU */
(0 real changes made)

. replace droplater=1 if ticker=="CSW" /* CANADA SOUTHERN PETROLEUM, surviving ticker: CSPLF */
(0 real changes made)

. replace droplater=1 if ticker=="CNR." /* CANADIAN NATIONAL RAILWAY CO, surviving ticker: CNI */
(0 real changes made)

. replace droplater=1 if ticker=="CNQ" /* CANADIAN NATURAL RESOURCES, surviving ticker: CNQ. */
(2 real changes made)

. replace droplater=1 if ticker=="CP." /* CANADIAN PACIFIC RAILWAY LTD, surviving ticker: CP */
(0 real changes made)

. replace droplater=1 if ticker=="SNG." /* CANADIAN SUPERIOR ENERGY INC, surviving ticker: SNG */
(0 real changes made)

. replace droplater=1 if ticker=="CVV." /* CANALASKA VENTURES LTD, surviving ticker: 3CVVLF */
(0 real changes made)

. replace droplater=1 if ticker=="CCM." /* CANARC RESOURCE CORP, surviving ticker: 3CRCUF */
(0 real changes made)

. replace droplater=1 if ticker=="CGS.NV" /* CANWEST GLOBAL COM  -NVTG, surviving ticker: CWG */
(0 real changes made)

. replace droplater=1 if ticker=="CDU" /* CARDERO RESOURCE CORP, surviving ticker: CDY */
(0 real changes made)

. replace droplater=1 if ticker=="CRME" /* CARDIOME PHARMA CORP, surviving ticker: COM */
(1 real change made)

. replace droplater=1 if ticker=="CLS.SV" /* CELESTICA INC, surviving ticker: CLS */
(0 real changes made)

. replace droplater=1 if ticker=="CEF.NV.A" /* CENTRAL FUND CANADA  -CL A, surviving ticker: CEF */
(0 real changes made)

. replace droplater=1 if ticker=="3250B" /* CENTRAL MINERA CORP, surviving ticker: 3CENMF */
(0 real changes made)

. replace droplater=1 if ticker=="CERTF" /* CERTICOM CORP, surviving ticker: CIC. */
(0 real changes made)

. replace droplater=1 if ticker=="CC." /* CHAI NA TA CORP, surviving ticker: 3CCCFF */
(0 real changes made)

. replace droplater=1 if ticker=="CRW." /* CINRAM INTERNATIONAL INC, surviving ticker: CNRMF */
(0 real changes made)

. replace droplater=1 if ticker=="CTM." /* CINTECH SOLUTIONS INC, surviving ticker: 3CMGFF */
(0 real changes made)

. replace droplater=1 if ticker=="CRJ" /* CLAUDE RESOURCES INC, surviving ticker: CGR */
(0 real changes made)

. replace droplater=1 if ticker=="CLV." /* CLEARLY CDN BEVERAGE CP, surviving ticker: 3CCBEF */
(0 real changes made)

. replace droplater=1 if ticker=="CDM" /* COEUR D'ALENE MINES CORP, surviving ticker: CDE */
(0 real changes made)

. replace droplater=1 if ticker=="CSN." /* COGNOS INC, surviving ticker: COGN */
(0 real changes made)

. replace droplater=1 if ticker=="3ZCCCF" /* COMMERCIAL CONSOLIDATORS CP, surviving ticker: CCZ.1 */
(0 real changes made)

. replace droplater=1 if ticker=="CMT." /* COMPTON PETROLEUM CORP, surviving ticker: CMZ */
(0 real changes made)

. replace droplater=1 if ticker=="CNY." /* CONIAGAS RESOURCES LTD, surviving ticker: 3COIGE */
(0 real changes made)

. replace droplater=1 if ticker=="CMC." /* CONSOLIDATED MERCANTILE INC, surviving ticker: CSLMF */
(0 real changes made)

. replace droplater=1 if ticker=="3CGREF" /* CORAL GOLD RESOURCES LTD, surviving ticker: CGR. */
(0 real changes made)

. replace droplater=1 if ticker=="CJR.NV.B" /* CORUS ENTERTAINMENT INC, surviving ticker: CJR */
(0 real changes made)

. replace droplater=1 if ticker=="BCB" /* COTT CORP QUE, surviving ticker: COT */
(0 real changes made)

. replace droplater=1 if ticker=="CXS." /* COUNSEL CORP, surviving ticker: CXSNF */
(0 real changes made)

. replace droplater=1 if ticker=="CRY." /* CRYPTOLOGIC INC, surviving ticker: CRYP */
(0 real changes made)

. replace droplater=1 if ticker=="KRY." /* CRYSTALLEX INTERNATIONAL CP, surviving ticker: KRY */
(0 real changes made)

. replace droplater=1 if ticker=="CLG" /* CUMBERLAND RESOURCES LTD, surviving ticker: CLG. */
(0 real changes made)

. replace droplater=1 if ticker=="0604B" /* CURRENT TECHNOLOGY CORP, surviving ticker: 3CRTCF */
(0 real changes made)

. replace droplater=1 if ticker=="CQC" /* CUSAC GOLD MINES LTD, surviving ticker: 3CUSIF */
(0 real changes made)

. replace droplater=1 if ticker=="2158B" /* DALECO RESOURCES CORP, surviving ticker: 3DLOV */
(0 real changes made)

. replace droplater=1 if ticker=="DTV." /* DATAWAVE SYSTEMS INC, surviving ticker: 3DWVS */
(0 real changes made)

. replace droplater=1 if ticker=="DMC." /* DATAMIRROR CORP, surviving ticker: DMCX */
(0 real changes made)

. replace droplater=1 if ticker=="DTGLF" /* DATEC GROUP LTD, surviving ticker: DGL. */
(4 real changes made)

. replace droplater=1 if ticker=="DTL" /* DECTRON INTERNATIONALE INC, surviving ticker: DECT */
(0 real changes made)

. replace droplater=1 if ticker=="DNR." /* DENBURY RESOURCES INC, surviving ticker: DNR */
(0 real changes made)

. replace droplater=1 if ticker=="DSG." /* DESCARTES SYSTEMS GROUP INC, surviving ticker: DSGX */
(0 real changes made)

. replace droplater=1 if ticker=="DSM." /* DESERT SUN MINING CORP, surviving ticker: DEZ */
(0 real changes made)

. replace droplater=1 if ticker=="8608B" /* DIAMANT ART CORP, surviving ticker: 3DIAAF */
(0 real changes made)

. replace droplater=1 if ticker=="9142B" /* DIVERSINET CORP, surviving ticker: 3DVNTF */
(0 real changes made)

. replace droplater=1 if ticker=="DTC." /* DOMTAR INC, surviving ticker: DTC */
(49 real changes made)

. replace droplater=1 if ticker=="DII.SV" /* DOREL INDUSTRIES INC, surviving ticker: DIIB */
(0 real changes made)

. replace droplater=1 if ticker=="DAX" /* DRAXIS HEALTH INC, surviving ticker: DRAX */
(0 real changes made)

. replace droplater=1 if ticker=="3248B" /* DUSA PHARMACEUTICALS INC, surviving ticker: DUSA */
(0 real changes made)

. replace droplater=1 if ticker=="DOL." /* DYNAMIC OIL & GAS INC, surviving ticker: DYOLF */
(0 real changes made)

. replace droplater=1 if ticker=="9624B" /* DYNAMOTIVE ENERGY SYS CORP, surviving ticker: 3DYMTF */
(0 real changes made)

. replace droplater=1 if ticker=="9198B" /* E DIGITAL CORP, surviving ticker: 3EDIG */
(0 real changes made)

. replace droplater=1 if ticker=="EGC" /* EG CAPITAL INC, surviving ticker: EGCFF */
(0 real changes made)

. replace droplater=1 if ticker=="EGO" /* ELDORADO GOLD CORP, surviving ticker: ELD */
(0 real changes made)

. replace droplater=1 if ticker=="8332B" /* ELEPHANT & CASTLE GROUP INC, surviving ticker: 3PUBSF */
(0 real changes made)

. replace droplater=1 if ticker=="ECA." /* ENCANA CORP, surviving ticker: ECA */
(0 real changes made)

. replace droplater=1 if ticker=="ENB." /* ENBRIDGE INC, surviving ticker: ENB */
(0 real changes made)

. replace droplater=1 if ticker=="ERF.U" /* ENERPLUS RESOURCES FUND, surviving ticker: ERF */
(0 real changes made)

. replace droplater=1 if ticker=="ENT.U" /* ENTERRA ENERGY TRUST, surviving ticker: EENC */
(0 real changes made)

. replace droplater=1 if ticker=="ETG." /* ENTREE GOLD INC, surviving ticker: EGI */
(0 real changes made)

. replace droplater=1 if ticker=="ECG" /* ENVOY COMMUNICATIONS GRP INC, surviving ticker: ECGI */
(0 real changes made)

. replace droplater=1 if ticker=="EEE.U" /* ESPRIT ENERGY TRUST, surviving ticker: EEEBF */
(0 real changes made)

. replace droplater=1 if ticker=="EZM" /* EUROZINC MINING CORP, surviving ticker: EZM. */
(0 real changes made)

. replace droplater=1 if ticker=="EXF.SV" /* EXFO ELECTRO OPTICAL ENGR, surviving ticker: EXFO */
(0 real changes made)

. replace droplater=1 if ticker=="EXE.SV" /* EXTENDICARE INC  -SVTG, surviving ticker: EXE */
(0 real changes made)

. replace droplater=1 if ticker=="TPC.Z" /* FEC RESOURCES INC, surviving ticker: 3FECOF */
(0 real changes made)

. replace droplater=1 if ticker=="FNX." /* FNX MINING CO INC, surviving ticker: FNX */
(0 real changes made)

. replace droplater=1 if ticker=="FFH" /* FAIRFAX FINANCIAL HOLDINGS, surviving ticker: FFH.SV */
(0 real changes made)

. replace droplater=1 if ticker=="FHR." /* FAIRMONT HOTELS RESORTS INC, surviving ticker: FHR */
(0 real changes made)

. replace droplater=1 if ticker=="FAL.LV" /* FALCONBRIDGE LTD, surviving ticker: FAL */
(0 real changes made)

. replace droplater=1 if ticker=="FTM" /* FANTOM TECHNOLOGIES INC, surviving ticker: FTMTQ */
(0 real changes made)

. replace droplater=1 if ticker=="FSV.SV" /* FIRSTSERVICE CORP  -SVTG, surviving ticker: FSRV */
(0 real changes made)

. replace droplater=1 if ticker=="FMI." /* FORBES MEDI-TECH INC, surviving ticker: FMTI */
(0 real changes made)

. replace droplater=1 if ticker=="FDG.U" /* FORDING CANADIAN COAL TRUST, surviving ticker: FDG */
(0 real changes made)

. replace droplater=1 if ticker=="FSH.SV" /* FOUR SEASONS HOTELS -LTD VTG, surviving ticker: FS */
(0 real changes made)

. replace droplater=1 if ticker=="FRG." /* FRONTEER DEVELOPMENT GRP INC, surviving ticker: FRG */
(0 real changes made)

. replace droplater=1 if ticker=="GSI." /* GSI GROUP INC, surviving ticker: GSIG */
(0 real changes made)

. replace droplater=1 if ticker=="GRS" /* GAMMON LAKE RESOURCES INC, surviving ticker: GAM. */
(0 real changes made)

. replace droplater=1 if ticker=="YGA" /* GASTAR EXPLORATION LTD, surviving ticker: GST */
(0 real changes made)

. replace droplater=1 if ticker=="GAC." /* GEAC COMPUTER CORP LTD, surviving ticker: GEAC */
(0 real changes made)

. replace droplater=1 if ticker=="GNA." /* GERDAU AMERISTEEL CORP, surviving ticker: GNA */
(0 real changes made)

. replace droplater=1 if ticker=="GIL." /* GILDAN ACTIVEWEAR INC, surviving ticker: GIL */
(0 real changes made)

. replace droplater=1 if ticker=="GLG." /* GLAMIS GOLD LTD, surviving ticker: GLG. */
(0 real changes made)

. replace droplater=1 if ticker=="GGG." /* GLENCAIRN GOLD CORP, surviving ticker: GLE */
(0 real changes made)

. replace droplater=1 if ticker=="GGB.Z" /* GLOBAL LT TELECOMMUNICATIONS, ticker: GBTI */
(0 real changes made)

. replace droplater=1 if ticker=="CLP." /* GLOBETECH VENTURES CORP, surviving ticker: 3GTVCF */
(0 real changes made)

. replace droplater=1 if ticker=="G." /* GOLDCORP INC, surviving ticker: GG */
(0 real changes made)

. replace droplater=1 if ticker=="GGR." /* GOLDEN GOOSE RESOURCE, surviving ticker: 3GGOSF */
(0 real changes made)

. replace droplater=1 if ticker=="GSC." /* GOLDEN STAR RESOURCES LTD, surviving ticker: GSS */
(0 real changes made)

. replace droplater=1 if ticker=="GNC." /* GORAN CAPITAL INC, surviving ticker: GNCN */
(0 real changes made)

. replace droplater=1 if ticker=="7637B" /* GRANDETEL TECHNOLOGIES INC, surviving ticker: GTTIF */
(0 real changes made)

. replace droplater=1 if ticker=="GBG" /* GREAT BASIN GOLD LTD, surviving ticker: GBN */
(14 real changes made)

. replace droplater=1 if ticker=="GIB" /* CGI GROUP INC  -CL A, surviving ticker: GIB.SV.A */
(1 real change made)

. replace droplater=1 if ticker=="HTE.U" /* HARVEST ENERGY TRUST, surviving ticker: HTE */
(0 real changes made)

. replace droplater=1 if ticker=="3269B" /* HEALTHTRAC INC, surviving ticker: HTAC */
(0 real changes made)

. replace droplater=1 if ticker=="HMSLQ" /* HEMOSOL CORP, surviving ticker: HML. */
(2 real changes made)

. replace droplater=1 if ticker=="HLG.C" /*HOLLINGER INC, surviving ticker: HLGAF */
(0 real changes made)

. replace droplater=1 if ticker=="HBG" /* HUB INTERNATIONAL LTD, surviving ticker: HBG. */
(0 real changes made)

. replace droplater=1 if ticker=="HUM." /* HUMMINGBIRD LTD, surviving ticker: HUMC */
(0 real changes made)

. replace droplater=1 if ticker=="HYG" /* HYDROGENICS CORP, surviving ticker: HYGA */
(0 real changes made)

. replace droplater=1 if ticker=="IMR" /* IMA EXPLORATION INC, surviving ticker: IMR. */
(0 real changes made)

. replace droplater=1 if ticker=="IMG." /* IAMGOLD CORP, surviving ticker: IAG */
(0 real changes made)

. replace droplater=1 if ticker=="IMX." /* IMAX CORP, surviving ticker: IMAX */
(0 real changes made)

. replace droplater=1 if ticker=="IGP" /* IMPERIAL GINSENG PRODS LTD, surviving ticker: IGPFF */
(0 real changes made)

. replace droplater=1 if ticker=="IMO." /* IMPERIAL OIL LTD, surviving ticker: IMO */
(0 real changes made)

. replace droplater=1 if ticker=="N." /* INCO LTD, surviving ticker: N */
(0 real changes made)

. replace droplater=1 if ticker=="INP" /* INFOCORP COMPUTER SOLUTIONS, surviving ticker: IFCSF */
(0 real changes made)

. replace droplater=1 if ticker=="INO" /* INOVIO BIOMEDICAL CORP, surviving ticker: GEB. */
(4 real changes made)

. replace droplater=1 if ticker=="3IBTGF" /* INTERNATIONAL BARRIER TECH I, surviving ticker: IBH */
(0 real changes made)

. replace droplater=1 if ticker=="7116B" /* INTL GEMINI TECH INC, surviving ticker: 6971B */
(0 real changes made)

. replace droplater=1 if ticker=="ITW." /* INTRAWEST CORP, surviving ticker: IDR */
(0 real changes made)

. replace droplater=1 if ticker=="ITP." /* INTERTAPE POLYMER GROUP INC, surviving ticker: ITP */
(0 real changes made)

. replace droplater=1 if ticker=="IOL" /* INTEROIL CORP, surviving ticker: IOC */
(0 real changes made)

. replace droplater=1 if ticker=="IPS." /* IPSCO INC, surviving ticker: IPS */
(0 real changes made)

. replace droplater=1 if ticker=="ITX" /* ITERATION ENERGY LTD, surviving ticker: ITXFF */
(0 real changes made)

. replace droplater=1 if ticker=="IE" /* IVANHOE ENERGY INC, surviving ticker: IVAN */
(0 real changes made)

. replace droplater=1 if ticker=="IVN" /* IVANHOE MINES LTD, surviving ticker: IVN. */
(0 real changes made)

. replace droplater=1 if ticker=="JCT." /* JEWETT-CAMERON TRADING CO, surviving ticker: JCTCF */
(0 real changes made)

. replace droplater=1 if ticker=="JSD" /* JONES SODA CO, surviving ticker: JSDA */
(0 real changes made)

. replace droplater=1 if ticker=="MXB.U" /* KHD HUMBOLDT WEDAG INTL LTD, surviving ticker: KHDH */
(0 real changes made)

. replace droplater=1 if ticker=="KBR" /* KIMBER RESOURCES INC surviving ticker: KBX */
(0 real changes made)

. replace droplater=1 if ticker=="K." /* KINROSS GOLD CORP, surviving ticker: KGC */
(0 real changes made)

. replace droplater=1 if ticker=="KFS" /* KINGSWAY FINANCIAL SVCS INC, surviving ticker: KFS. */
(0 real changes made)

. replace droplater=1 if ticker=="LMZ." /* LMS MEDICAL SYSTEMS INC, surviving ticker: LMZ */
(0 real changes made)

. replace droplater=1 if ticker=="KRK" /* LML PAYMENT SYSTEMS INC, surviving ticker: LMLP */
(0 real changes made)

. replace droplater=1 if ticker=="BUS." /* LAIDLAW INTERNATIONAL INC, surviving ticker: LI */
(0 real changes made)

. replace droplater=1 if ticker=="LAG" /* LAURION GOLD INC, surviving ticker: LAGFF */
(0 real changes made)

. replace droplater=1 if ticker=="9008B" /* LEADING BRANDS INC, surviving ticker: LBIX */
(0 real changes made)

. replace droplater=1 if ticker=="LVN" /* LEVON RESOURCES LTD, surviving ticker: 3LVNVE */
(0 real changes made)

. replace droplater=1 if ticker=="LIM" /* LIONORE MINING INTL LTD, surviving ticker: 3LMGGF */
(0 real changes made)

. replace droplater=1 if ticker=="LGF." /* LIONS GATE ENTMT CORP, surviving ticker: LGF */
(0 real changes made)

. replace droplater=1 if ticker=="LQW" /* LIQUIDATION WORLD INC, surviving ticker: LIQWF */
(0 real changes made)

. replace droplater=1 if ticker=="LOR." /* LORUS THERAPEUTICS INC, surviving ticker: LRP */
(0 real changes made)

. replace droplater=1 if ticker=="MDZ.SV.A" /* MDC PARTNERS INC, surviving ticker: MDCA */
(0 real changes made)

. replace droplater=1 if ticker=="MDZ" /* MDS INC, surviving ticker: MDS. */
(0 real changes made)

. replace droplater=1 if ticker=="MIM.SV.A" /* MI DEVELOPMENTS INC, surviving ticker: MIM */
(0 real changes made)

. replace droplater=1 if ticker=="MCZ." /* MAD CATZ INTERACTIVE INC, surviving ticker: MCZ */
(0 real changes made)

. replace droplater=1 if ticker=="3MMRSF" /* MADISON MINERALS INC, surviving ticker: MMR. */
(0 real changes made)

. replace droplater=1 if ticker=="MEC.SV.A" /* MAGNA ENTERTAINMENT CORP, surviving ticker: MECA */
(0 real changes made)

. replace droplater=1 if ticker=="MG.SV.A" /* MAGNA INTERNATIONAL  -CL A, surviving ticker: MGA */
(0 real changes made)

. replace droplater=1 if ticker=="8627B" /* MAMMA.COM INC, surviving ticker: MAMA */
(0 real changes made)

. replace droplater=1 if ticker=="MFC." /* MANULIFE FINANCIAL CORP, surviving ticker: MFC */
(0 real changes made)

. replace droplater=1 if ticker=="3393B" /* MED-EMERG INTERNATIONAL INC, surviving ticker: 3MDER */
(0 real changes made)

. replace droplater=1 if ticker=="MPH." /* MEDICURE INC, surviving ticker: MCU */
(0 real changes made)

. replace droplater=1 if ticker=="MNG." /* MERIDIAN GOLD INC, surviving ticker: MDG */
(0 real changes made)

. replace droplater=1 if ticker=="MR." /* METALLICA RESOURCES INC, surviving ticker: MRB */
(0 real changes made)

. replace droplater=1 if ticker=="MX." /* METHANEX CORP, surviving ticker: MEOH */
(0 real changes made)

. replace droplater=1 if ticker=="0455B" /* MICROMEM TECHNOLOGIES INC, surviving ticker: 3MMTIF */
(0 real changes made)

. replace droplater=1 if ticker=="MGI." /* MIGENIX INC, surviving ticker: 3MGIFF */
(0 real changes made)

. replace droplater=1 if ticker=="MMM." /* MINCO MINING & METALS CORP, surviving ticker: MMK */
(0 real changes made)

. replace droplater=1 if ticker=="MFN" /* MINEFINDERS CORP LTD, surviving ticker: MFL. */
(0 real changes made)

. replace droplater=1 if ticker=="MAE" /* MIRAMAR MINING CORP, surviving ticker: MNG */
(0 real changes made)

. replace droplater=1 if ticker=="MNT." /* MIRTRONICS INC, surviving ticker: 3MNTCE */
(0 real changes made)

. replace droplater=1 if ticker=="MPV." /* MOUNTAIN PROVINCE DIAMONDS, surviving ticker: MDM */
(0 real changes made)

. replace droplater=1 if ticker=="NBS." /* NBS TECHNOLOGIES INC, surviving ticker: NBSFF */
(0 real changes made)

. replace droplater=1 if ticker=="7518B" /* NGAS RESOURCES INC, surviving ticker: NGAS */
(0 real changes made)

. replace droplater=1 if ticker=="NQL." /* NQL ENERGY SERVICES INC, surviving ticker: 3NQDRF */
(0 real changes made)

. replace droplater=1 if ticker=="NRM" /* NEUROCHEM INC, surviving ticker: NRMX */
(0 real changes made)

. replace droplater=1 if ticker=="NEV." /* NEVADA STAR RESOURCE CORP, surviving ticker: 3NVSRF */
(0 real changes made)

. replace droplater=1 if ticker=="NSU" /* NEVSUN RESOURCES LTD, surviving ticker: NSU. */
(0 real changes made)

. replace droplater=1 if ticker=="NGD." /* NEW GOLD INC, surviving ticker: NGD */
(0 real changes made)

. replace droplater=1 if ticker=="NXY." /* NEXEN INC, surviving ticker: NXY */
(0 real changes made)

. replace droplater=1 if ticker=="3636B" /* NICHOLAS FINANCIAL INC, surviving ticker: NICK */
(0 real changes made)

. replace droplater=1 if ticker=="NBD." /* NORBORD INC, surviving ticker: NBDFF */
(0 real changes made)

. replace droplater=1 if ticker=="NII." /* NORSAT INTL INC, surviving ticker: 3NSATF */
(0 real changes made)

. replace droplater=1 if ticker=="NT." /* NORTEL NETWORKS CORP, surviving ticker: NT */
(0 real changes made)

. replace droplater=1 if ticker=="PDL" /* NORTH AMERICAN PALLADIUM, surviving ticker: PAL */
(0 real changes made)

. replace droplater=1 if ticker=="NDM" /* NORTHERN DYNASTY MINERAL LTD, surviving ticker: NAK */
(0 real changes made)

. replace droplater=1 if ticker=="NHD" /* NORTHERN HEMISPHERE DEV CP, surviving ticker: 3HSDME */
(0 real changes made)

. replace droplater=1 if ticker=="NNO." /* NORTHERN ORION RESOURCES INC, surviving ticker: NTO */
(0 real changes made)

. replace droplater=1 if ticker=="NGX." /* NORTHGATE MINERALS CORP, surviving ticker: NGX */
(0 real changes made)

. replace droplater=1 if ticker=="NCX." /* NOVA CHEMICALS CORP, surviving ticker: NCX */
(0 real changes made)

. replace droplater=1 if ticker=="NG." /* NOVAGOLD RESOURCES LTD, surviving ticker: NG */
(0 real changes made)

. replace droplater=1 if ticker=="3311B" /* NOVAMERICAN STEEL INC, surviving ticker: TONS */
(0 real changes made)

. replace droplater=1 if ticker=="NVL." /* NOVELIS INC, surviving ticker: NVL */
(0 real changes made)

. replace droplater=1 if ticker=="NCS." /* NUCRYST PHARM CORP -REDH, surviving ticker: NCST */
(0 real changes made)

. replace droplater=1 if ticker=="0115B" /* NYMOX PHARMACEUTICAL CORP, surviving ticker: NYMX */
(0 real changes made)

. replace droplater=1 if ticker=="3OFSYF" /* OFFSHORE SYSTEMS INTL LTD, surviving ticker: OSI. */
(0 real changes made)

. replace droplater=1 if ticker=="ONC" /* ONCOLYTICS BIOTECH INC, surviving ticker: ONCY */
(0 real changes made)

. replace droplater=1 if ticker=="OTC" /* OPEN TEXT CORP, surviving ticker: OTEX */
(0 real changes made)

. replace droplater=1 if ticker=="OPY.NV" /* OPPENHEIMER HLDGS INC  -CL A, surviving ticker: OPY */
(0 real changes made)

. replace droplater=1 if ticker=="2129B" /* OPTIMAL GROUP INC, surviving ticker: 2129B */
(0 real changes made)

. replace droplater=1 if ticker=="OZN." /* OREZONE RESOURCES INC, surviving ticker: OZN */
(0 real changes made)

. replace droplater=1 if ticker=="OTT.U" /* OTELCO INC, suviving ticker: OTT */
(0 real changes made)

. replace droplater=1 if ticker=="7598B" /* PLC SYSTEMS INC, surviving ticker: PLC */
(0 real changes made)

. replace droplater=1 if ticker=="PMU." /* PACIFIC RIM MINING CORP, surviving ticker: PMU */
(0 real changes made)

. replace droplater=1 if ticker=="PAA." /* PAN AMERICAN SILVER CORP, surviving ticker: PAAS */
(0 real changes made)

. replace droplater=1 if ticker=="PEI." /* PARLAY ENTERTAINMENT INC, surviving ticker: PRYNF */
(0 real changes made)

. replace droplater=1 if ticker=="PAE.LV"  /* PEACE ARCH ENTMT GROUP INC, surviving ticker: PAE */ 
(0 real changes made)

. replace droplater=1 if ticker=="PGF.A" /* PENGROWTH ENERGY TRUST, surviving ticker: PGH */
(0 real changes made)

. replace droplater=1 if ticker=="PCR." /* PERU COPPER INC, surviving ticker: CUP */
(0 real changes made)

. replace droplater=1 if ticker=="PTQ" /* PETAQUILLA MINERALS LTD, surviving ticker: 3PTQMF */
(0 real changes made)

. replace droplater=1 if ticker=="PCA." /* PETRO-CANADA, surviving ticker: PCZ */
(0 real changes made)

. replace droplater=1 if ticker=="PTF.U" /* PETROFUND ENERGY TRUST, surviving ticker: PFT */
(0 real changes made)

. replace droplater=1 if ticker=="PQU" /* PETROQUEST ENERGY INC, suviving ticker: PQ */
(0 real changes made)

. replace droplater=1 if ticker=="PDG." /* PLACER DOME INC, surviving ticker: PDG */
(0 real changes made)

. replace droplater=1 if ticker=="LAN." /* PLAINTREE SYSTEMS INC, surviving ticker: 3LANPF */
(0 real changes made)

. replace droplater=1 if ticker=="PPK." /* POLYAIR INTER PACK INC, surviving ticker: PPK */
(0 real changes made)

. replace droplater=1 if ticker=="PYM." /* POLYMER SOLUTIONS INC, surviving ticker: 3PYSU */
(0 real changes made)

. replace droplater=1 if ticker=="POM." /* POLYMET MINING CORP, surviving ticker: 3POMGF */
(0 real changes made)

. replace droplater=1 if ticker=="POT." /* POTASH CORP SASK INC, surviving ticker: POT */
(0 real changes made)

. replace droplater=1 if ticker=="PRP" /* PRAIRIE PACIFIC ENERGY CORP, surviving ticker: 3PRPEF */
(0 real changes made)

. replace droplater=1 if ticker=="PD.U" /* PRECISION DRILLING TRUST, surviving ticker: PDS */
(0 real changes made)

. replace droplater=1 if ticker=="PMD." /* PREMD INC, surviving ticker: PME */
(0 real changes made)

. replace droplater=1 if ticker=="PBI.U" /* PREMIUM BRANDS INCOME FUND, surviving ticker: PRMBF */
(0 real changes made)

. replace droplater=1 if ticker=="PWI.U" /* PRIMEWEST ENERGY TRUST, surviving ticker: PWI */
(0 real changes made)

. replace droplater=1 if ticker=="7050B" /* PRINCETON MEDIA GROUP INC, surviving ticker: PMGIF */
(0 real changes made)

. replace droplater=1 if ticker=="PVE.U" /* PROVIDENT ENERGY TRUST, surviving ticker: PVX */
(0 real changes made)

. replace droplater=1 if ticker=="QLT" /* QLT INC, surviving ticker: GLTI */
(0 real changes made)

. replace droplater=1 if ticker=="AAZ" /* QSOUND LABS INC, surviving ticker: QSND */
(0 real changes made)

. replace droplater=1 if ticker=="QZM" /* QUARTZ MOUNTAIN RESOURCES, surviving ticker: 3QZMRE */
(0 real changes made)

. replace droplater=1 if ticker=="QBR.SV.B" /* QUEBECOR INC  -CL B, surviving ticker: 3QBCRF */
(0 real changes made)

. replace droplater=1 if ticker=="IQW.SV" /* QUEBECOR WORLD INC  -SUB VTG, surviving ticker: IQW */
(0 real changes made)

. replace droplater=1 if ticker=="QRL" /* QUEENSTAKE RES LTD YUKON, surviving ticker: QEE */
(0 real changes made)

. replace droplater=1 if ticker=="QC" /* QUEST CAPITAL CORP, surviving ticker: QCC */
(0 real changes made)

. replace droplater=1 if ticker=="GHVRF" /* RED LAKE RESOURCES INC, surviving ticker: RL. */
(0 real changes made)

. replace droplater=1 if ticker=="RLO." /* REGALITO COPPER CORP, surviving ticker: RLO */
(0 real changes made)

. replace droplater=1 if ticker=="RGF." /* REPUBLIC GOLDFIELDS, surviving ticker: 3RPGDF */
(0 real changes made)

. replace droplater=1 if ticker=="RIM" /* RESEARCH IN MOTION LTD, surviving ticker: RIMM */
(0 real changes made)

. replace droplater=1 if ticker=="RPC." /* REVENUE PROPERTIES CO LTD, surviving ticker: RPCFF */
(13 real changes made)

. replace droplater=1 if ticker=="RIC." /* RICHMONT MINES INC, surviving ticker: RIC */
(0 real changes made)

. replace droplater=1 if ticker=="RNO" /* RIO NARCEA GOLD MINES LTD, surviving ticker: RNG */
(0 real changes made)

. replace droplater=1 if ticker=="RBA." /* RITCHIE BROS AUCTIONEERS INC, surviving ticker: RBS */
(0 real changes made)

. replace droplater=1 if ticker=="RTI." /* RIVAL TECHNOLOGIES INC, surviving ticker: 3RVTI */
(0 real changes made)

. replace droplater=1 if ticker=="RE." /* ROCK ENERGY INC, surviving ticker: RENFF */
(0 real changes made)

. replace droplater=1 if ticker=="RCI.NV.B" /* ROGERS COMMUNICATIONS  -CL B, surviving ticker: RG */
(0 real changes made)

. replace droplater=1 if ticker=="3591B" /* ROSEDALE DECORATIVE PROD LTD, surviving ticker: ROSD */
(0 real changes made)

. replace droplater=1 if ticker=="RYG." /* ROYAL GROUP TECHNOLOGIES LTD, surviving ticker: RYG */
(0 real changes made)

. replace droplater=1 if ticker=="ROY.U" /* ROYSTER-CLARK LTD, surviving ticker: 0912B */
(0 real changes made)

. replace droplater=1 if ticker=="RMX." /* RUBICON MINERALS CORP, surviving ticker: RBY */
(0 real changes made)

. replace droplater=1 if ticker=="RSM" /* ROYAL STANDARD MINERALS INC, surviving ticker: 3RYSMF */
(0 real changes made)

. replace droplater=1 if ticker=="RUS." /* RUSSEL METALS INC, surviving ticker: RUSMF */
(0 real changes made)

. replace droplater=1 if ticker=="SRXAF" /* S R TELECOM INC, surviving ticker: SRX. */
(0 real changes made)

. replace droplater=1 if ticker=="9022B" /* SCHMITT INDUSTRIES INC/OR, surviving ticker: SMIT */
(0 real changes made)

. replace droplater=1 if ticker=="SLP." /* SCINTILORE EXPLORATIONS LTD, surviving ticker: SLPFF */
(0 real changes made)

. replace droplater=1 if ticker=="SEA." /* SEABRIDGE GOLD INC, surviving ticker: SA */
(0 real changes made)

. replace droplater=1 if ticker=="3SNSG" /* 3SNSGSENSE TECHNOLOGIES INC, surviving ticker: SSE.Z */
(0 real changes made)

. replace droplater=1 if ticker=="SVN" /* 724 SOLUTIONS INC, surviving ticker: SVNX */
(0 real changes made)

. replace droplater=1 if ticker=="SJR" /* SHAW COMMUNICATIONS INC-CL B, surviving ticker: SJR.NV.B */
(11 real changes made)

. replace droplater=1 if ticker=="SHC." /* SHELL CANADA LTD  -CL A, surviving ticker: 3SCUAF */
(12 real changes made)

. replace droplater=1 if ticker=="0416B" /* SHEP TECHNOLOGIES INC, surviving ticker: STLOF */
(0 real changes made)

. replace droplater=1 if ticker=="SW." /* SIERRA WIRELESS INC, surviving ticker: SWIR */
(0 real changes made)

. replace droplater=1 if ticker=="SWE" /* SILENT WITNESS ENTERPRISES, surviving ticker: SILWF */
(0 real changes made)

. replace droplater=1 if ticker=="8710B" /* SILVERADO GOLD MINES LTD, surviving ticker: 3SLGLF */
(0 real changes made)

. replace droplater=1 if ticker=="SSO" /* SILVER STANDARD RES INC, surviving ticker: SSRI */
(0 real changes made)

. replace droplater=1 if ticker=="SLW" /* SILVER WHEATON CORP, surviving ticker: SLW. */
(0 real changes made)

. replace droplater=1 if ticker=="SOLI" /* SOLITARIO RESOURCES CORP, surviving ticker: SLR. */
(0 real changes made)

. replace droplater=1 if ticker=="SDI" /* SPECTRAL DIAGNOSTICS INC, surviving ticker: DIAGF */
(0 real changes made)

. replace droplater=1 if ticker=="SSY." /* SPECTRUM SIGNAL PROCESSING, surviving ticker: SSPI */
(0 real changes made)

. replace droplater=1 if ticker=="SXC" /* STANTEC INC, surviving ticker: STN. */
(0 real changes made)

. replace droplater=1 if ticker=="SLX" /* STELLAR PHARMACEUTICALS INC, surviving ticker: 3SLXCF */
(0 real changes made)

. replace droplater=1 if ticker=="SGD" /* STERLITE GOLD LTD, surviving ticker: SGDTF */
(0 real changes made)

. replace droplater=1 if ticker=="SME" /* STORM CAT ENERGY CORP, surviving ticker: SCU */
(0 real changes made)

. replace droplater=1 if ticker=="SLF." /* SUN LIFE FINANCIAL INC, surviving ticker: SLF */
(0 real changes made)

. replace droplater=1 if ticker=="SU." /* SUNCOR ENERGY INC, surviving ticker: SU */
(0 real changes made)

. replace droplater=1 if ticker=="SOY" /* SUNOPTA INC, surviving ticker: STKL */
(0 real changes made)

. replace droplater=1 if ticker=="TLC" /* TLC VISION CORP, surviving ticker: TLSV */
(0 real changes made)

. replace droplater=1 if ticker=="TLM." /* TALISMAN ENERGY INC, surviving ticker: TLM */
(0 real changes made)

. replace droplater=1 if ticker=="TNX" /* TAN RANGE EXPLORATION CP, surviving ticker: TRE */
(0 real changes made)

. replace droplater=1 if ticker=="TKO." /* TASEKO MINES LTD, surviving ticker: TGB */
(0 real changes made)

. replace droplater=1 if ticker=="TNC." /* TELESIS NORTH COMMUNICATIONS, surviving ticker: TNCVF */
(0 real changes made)

. replace droplater=1 if ticker=="TU" /* TELUS CORP, surviving ticker: T.NV */
(8 real changes made)

. replace droplater=1 if ticker=="TIW." /* TELESYSTEM INTL WIRELESS INC, surviving ticker: TIWIF */
(0 real changes made)

. replace droplater=1 if ticker=="TEO." /* TESCO CORP, surviving ticker: TESOF */
(0 real changes made)

. replace droplater=1 if ticker=="TOC." /* THOMSON CORP, surviving ticker: TOC */
(0 real changes made)

. replace droplater=1 if ticker=="0458B" /* TRANS ORIENT PETROLEUM LTD, surviving ticker: 3TOPLF */
(0 real changes made)

. replace droplater=1 if ticker=="TAC" /* TRANSALTA CORP, surviving ticker: TA: */
(4 real changes made)

. replace droplater=1 if ticker=="TRP." /* TRANSCANADA CORP, surviving ticker: TRP */
(0 real changes made)

. replace droplater=1 if ticker=="TGL." /* TRANSGLOBE ENERGY CORP, surviving ticker: TGA */
(0 real changes made)

. replace droplater=1 if ticker=="TRZ.1" /* TRIZEC PROPERTIES INC, surviving ticker: TRZ */
(0 real changes made)

. replace droplater=1 if ticker=="TDR." /* TUDOR CORP LTD, surviving ticker: TDRLF */
(0 real changes made)

. replace droplater=1 if ticker=="UP" /* ULTRA PETROLEUM CORP, surviving ticker: UPL */
(0 real changes made)

. replace droplater=1 if ticker=="UVI" /* UNILENS VISION INC, surviving ticker: 3UVICF */
(0 real changes made)

. replace droplater=1 if ticker=="VAS." /* VASOGEN INC, surviving ticker: VSGN */
(0 real changes made)

. replace droplater=1 if ticker=="VIR." /* VIREXX MEDICAL CORP, surviving ticker: REX */
(0 real changes made)

. replace droplater=1 if ticker=="VGZ." /* VIREXX MEDICAL CORPVISTA GOLD CORP, surviving ticker: VGZ */
(0 real changes made)

. replace droplater=1 if ticker=="3VISRF" /* VISIPHOR CORP, surviving ticker: VIS. */
(0 real changes made)

. replace droplater=1 if ticker=="VTN." /* VITRAN CORP INC, surviving ticker: VTNC */
(0 real changes made)

. replace droplater=1 if ticker=="WCS.SV.A" /* WESCAST INDUSTRIES  -CL A, surviving ticker: WCSTF */
(0 real changes made)

. replace droplater=1 if ticker=="WED" /* WESTAIM CORP, surviving ticker: WEDX */
(0 real changes made)

. replace droplater=1 if ticker=="WTZ" /* WESTERN SILVER CORP, surviving ticker: WTC */
(0 real changes made)

. replace droplater=1 if ticker=="9354B" /* WIDECOM GROUP INC, surviving ticker: WIDE */
(0 real changes made)

. replace droplater=1 if ticker=="WHT." /* WORLD HEART CORP, surviving ticker: WHRT */
(0 real changes made)

. replace droplater=1 if ticker=="YM" /* YM BIOSCIENCES INC, surviving ticker: YMI */
(0 real changes made)

. replace droplater=1 if ticker=="YRI" /* YAMANA GOLD INC, surviving ticker: AUY */
(0 real changes made)

. replace droplater=1 if ticker=="ZIC" /* ZI CORP, surviving ticker: ZICA */
(0 real changes made)

. replace droplater=1 if ticker=="ZL." /* ZARLINK SEMICONDUCTOR INC, surviving ticker: ZL */
(0 real changes made)

. replace droplater=1 if ticker=="8115B" /* ZOOM TECHNOLOGIES INC, surviving ticker: ZOOM */
(0 real changes made)

. replace droplater=1 if ticker=="ZTE" /* ZTEST ELECTRONICS INC, surviving ticker: ZTSTF */
(0 real changes made)

. replace droplater=1 if ticker=="POC.SV.B" /* PAN-OCEAN ENERGY CORP -CL B, surviving ticker: PNYBF */
(0 real changes made)

. replace droplater=1 if ticker=="SVS.U" /* SEVEN SEAS PETROLEUM INC, surviving ticker: 3SVSSF */
(0 real changes made)

. 
. drop if droplater==1
(139 observations deleted)

. drop droplater

. desc

Contains data from raw data\segments_1986-1999.dta
  obs:       170,647                          
 vars:             9                          
 size:    18,771,170                          
------------------------------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
------------------------------------------------------------------------------------------------------------------------------------------
gvkey           str6    %6s                   Global Company Key - Segment Annual Fundamentals
ta_segm         double  %18.0g                Identifiable (Total) Assets
rds_segm        double  %18.0g                Research and Development
sics1           str4    %4s                   SIC Code (Primary)
conm            str58   %58s                  Company Name
ticker          str8    %8s                   Ticker Symbol
cusip_segm      str10   %10s                  CUSIP
year            float   %9.0g                 fiscal year
sales_segm      float   %9.0g                 Sales - foreign sales
------------------------------------------------------------------------------------------------------------------------------------------
Sorted by:  
     Note:  dataset has changed since last saved

. 
. 
. save "segmentdata.dta", replace
file segmentdata.dta saved

. log close
      name:  <unnamed>
       log:  E:\REStat_MS14767_Vol96(2)\Data preparation Compustat segment\2_segmentdata.log
  log type:  text
 closed on:  18 Dec 2014, 18:05:19
------------------------------------------------------------------------------------------------------------------------------------------
